use "RR_Delta_AFY.dta", clear



**** Appendix Table A3: Irrigation District and Settlement Summary Statistics
********************************************************************************
********************************************************************************

eststo clear
estpost sum pctdelta xlinPct fundafy_nz afAcrePre afAcrePost hayAdj urbanizeRate d12t50c acres USBRpct CPIn reslnprimen respopAdjn UrbanGrowthn N_idn

esttab , cells("mean sd min max count")  nomtitle nonumber noobs




**** Table 1: Relationship between Shortage Risk and %∆ AFY
********************************************************************************
********************************************************************************

areg pctdelta xlinPct, absorb(settlement) robust

areg pctdelta xlinPct urbanizeRate, absorb(settlement) robust

areg pctdelta xlinPct urbanizeRate acres hayAdj, absorb(settlement) robust

areg pctdelta xlinPct urbanizeRate acres hayAdj afAcrePre, absorb(settlement) robust

areg pctdelta xlinPct urbanizeRate acres hayAdj afAcrePre d12t50c, absorb(settlement) robust

areg pctdelta xlinPct urbanizeRate acres hayAdj afAcrePre d12t50c USBRpct, absorb(settlement) robust




**** Appendix Table A4: Relationship between Shortage Risk^2 and %∆ AFY
**** Robustness Check 1
********************************************************************************
********************************************************************************

areg pctdelta xquadPct x2quadPct, absorb(settlement) robust

areg pctdelta xquadPct x2quadPct urbanizeRate, absorb(settlement) robust

areg pctdelta xquadPct x2quadPct urbanizeRate acres hayAdj, absorb(settlement) robust

areg pctdelta xquadPct x2quadPct urbanizeRate acres hayAdj afAcrePre, absorb(settlement) robust

areg pctdelta xquadPct x2quadPct urbanizeRate acres hayAdj afAcrePre d12t50c, absorb(settlement) robust

areg pctdelta xquadPct x2quadPct urbanizeRate acres hayAdj afAcrePre d12t50c USBRpct, absorb(settlement) robust



**** Appendix Table A5:  Relationship between Shortage Risk and %∆ AFY
**** Robustness Check 2 (State FE)
********************************************************************************
********************************************************************************

areg pctdelta xlinPct reslnprime, absorb(state) robust

areg pctdelta xlinPct reslnprime respopAdj, absorb(state) robust

areg pctdelta xlinPct reslnprime respopAdj UrbanGrowth, absorb(state) robust

areg pctdelta xlinPct reslnprime respopAdj UrbanGrowth N_id, absorb(state) robust

areg pctdelta xlinPct reslnprime respopAdj UrbanGrowth N_id d12t50c, absorb(state) robust

areg pctdelta xlinPct reslnprime respopAdj UrbanGrowth N_id d12t50c USBRpct, absorb(state) robust



**** Table A6:   Relationship between Shortage Risk and %∆ AFY
**** Robustness Check 3 (State FE)
********************************************************************************
********************************************************************************

areg pctdelta xquadPct x2quadPct reslnprime, absorb(state) robust

areg pctdelta xquadPct x2quadPct reslnprime respopAdj, absorb(state) robust

areg pctdelta xquadPct x2quadPct reslnprime respopAdj UrbanGrowth, absorb(state) robust

areg pctdelta xquadPct x2quadPct reslnprime respopAdj UrbanGrowth N_id, absorb(state) robust

areg pctdelta xquadPct x2quadPct reslnprime respopAdj UrbanGrowth N_id d12t50c, absorb(state) robust

areg pctdelta xquadPct x2quadPct reslnprime respopAdj UrbanGrowth N_id d12t50c USBRpct, absorb(state) robust
